﻿using System;
using System.Collections.Generic;
using System.Linq;
using SqlSugar;
namespace Zhao.Models.Entity
{
    /// <summary>
    /// 通知表（信息发布）
    ///</summary>
    [SugarTable("Notifications")]
    public class Notifications
    {
        /// <summary>
        /// 备  注:
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "NotificationID", IsPrimaryKey = true, IsIdentity = true)]
        public int NotificationID { get; set; }

        /// <summary>
        /// 备  注:通知标题（如"系统维护通知"）
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "Title")]
        public string Title { get; set; } = null!;

        /// <summary>
        /// 备  注:通知内容（支持富文本格式）
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "Content")]
        public string Content { get; set; } = null!;

        /// <summary>
        /// 备  注:发布人ID（外键关联Users表）
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "PublisherID")]
        public int PublisherID { get; set; }

        /// <summary>
        /// 备  注:关联球馆ID（1表示平台通知）
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "VenueID")]
        public Guid? VenueID { get; set; }

        /// <summary>
        /// 备  注:通知类型：1-后台通知，5-用户通知
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "NotificationType")]
        public short NotificationType { get; set; }

        /// <summary>
        /// 备  注:软删除标记
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "IsDeleted")]
        public short? IsDeleted { get; set; }

        /// <summary>
        /// 备  注:发布时间
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "PublishTime")]
        public DateTime? PublishTime { get; set; }

        /// <summary>
        /// 备  注:自动下架时间（NULL表示永久有效）
        /// 默认值:
        ///</summary>
        [SugarColumn(ColumnName = "ExpiryTime")]
        public DateTime? ExpiryTime { get; set; }
        /// <summary>
        /// 备  注:通知附带的图片
        /// 默认值: 
        [SugarColumn(ColumnName = "Image")]
        public string? Image { get; set; }
        /// <summary>
        /// 备  注:公告状态(1 展示中，3已过指定日期 5下架)
        /// 默认值: 
        [SugarColumn(ColumnName = "Status")]
        public short Status { get; set; }
    }

}